[client]
port    = <%= @port %>
socket    = <%= @socket %>
[mysqld_safe]
socket    = <%= @socket %>
nice    = 0
<% if @use_syslog -%>
syslog
<% end -%>
[mysqld]
innodb_file_per_table=1
<% if @operatingsystem != 'RedHat' %>
table_open_cache=<%= @table_open_cache %>
innodb_file_format=Barracuda
<% else %>
table_cache=<%= @table_open_cache %>
<% end %>
user    = mysql
#pid-file  = <%= @pidfile %>
socket    = <%= @socket %>
port      = <%= @port %>
basedir   = <%= @basedir %>
datadir   = <%= @datadir %>
tmpdir    = /tmp
skip-external-locking
bind-address    = <%= @bind_address %>
max_allowed_packet = 256M
thread_stack       = 192K
thread_cache_size  = 8
myisam-recover     = BACKUP
query_cache_limit  = 1M
query_cache_size   = 16M
<% if @mysql_buffer_pool_size %>
innodb_buffer_pool_size=<%= @mysql_buffer_pool_size %>
<% if @innodb_log_file_size_real != '0' %>
innodb_log_file_size=<%= @innodb_log_file_size_real %>
<% end %>
<% end %>
innodb_thread_concurrency= 0
innodb_write_io_threads  = 2
innodb_read_io_threads   = 8
innodb_io_capacity       = 500
key_buffer_size          = <%= @key_buffer_size %>
myisam_sort_buffer_size  = <%= @myisam_sort_buffer_size %>
wait_timeout             = <%= @wait_timeout %>
open_files_limit         = <%= @open_files_limit %>
<% if @use_syslog -%>
#log_error          = syslog:local1
<% else -%>
log_error          = <%= @log_error %>
<% end -%>
expire_logs_days   = 10
max_binlog_size    = 100M
max_connections    =  <%= @max_connections %>
<% if @default_engine != 'UNSET' %>
default-storage-engine = <%= @default_engine %>
<% end %>
<% if @ssl == true %>
ssl-ca    = <%= @ssl_ca %>
ssl-cert  = <%= @ssl_cert %>
ssl-key   = <%= @ssl_key %>
<% end %>
<% if @debug %>
slow_query_log = 1
long_query_time = 10
log_queries_not_using_indexes = 1
<% end %>
<% if @custom_setup_class == 'pacemaker_mysql' %>
server-id=<%= @server_id %>
log-bin=mysql-bin
relay-log=mysqld-relay-bin
replicate-ignore-db=mysql
<% end %>
collation-server = utf8_general_ci
init-connect='SET NAMES utf8'
character-set-server = utf8
explicit_defaults_for_timestamp = TRUE
[mysqldump]
quick
quote-names
max_allowed_packet = 16M
[mysql]
[isamchk]
key_buffer_size    = 16M
!includedir /etc/mysql/conf.d/
